using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Data.SqlClient;
namespace QuanLyThietBi.Manager
{
                

    public class TBL_NhomQuanLyManager:QuanLyThietBi.ManagerBase.TBL_NhomQuanLyManagerBase
    {
            public static TBL_NhomQuanLyManager CreateInstant()
            {
                return new TBL_NhomQuanLyManager();
            }
            public DataTable LayDanhSachNhomQuanLy()
            {
                string strsql = "select ROW_NUMBER () Over (order by Manhomquanly) as STT,* from TBL_NhomQuanLy";
                return SqlHelper.ExecuteDataTable(Config.ConnectionConfig.ConnectionString, CommandType.Text, strsql);
            }
            //public DataTable GetMaNhomQL(out string mama)
            //{
            //    SqlParameter[] param = new SqlParameter[1];
            //    param[0] = new SqlParameter("@ma", mama);

            //    string sp = "P_GetMaNhomQL";
            //    return SqlHelper.ExecuteDataTable(Config.ConnectionConfig.ConnectionString, CommandType.StoredProcedure,sp,param);
            //}

            //public string GetMaNhomQL()
            //{
            //    SqlParameter[] param = new SqlParameter[1];
            //    string sp = "P_GetMaNhomQL";
            //    param[0] = new SqlParameter("@ma", "");
            //    param[0].Direction = ParameterDirection.Output;
            //    param[0].DbType = DbType.String;
            //    param[0].Size = 10;
            //    SqlHelper.ExecuteNonQuery(Config.ConnectionConfig.ConnectionString, CommandType.StoredProcedure, sp, param);
                

            //    return param[0].Value.ToString();
            //}


    }
}
                    
